#coding:utf-8
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, TIMESTAMP
from sqlalchemy import Sequence
import sys
reload(sys)
sys.setdefaultencoding("utf-8")
Base = declarative_base()

class Order(Base):

	__tablename__ = "order"
	
	id = Column(Integer, Sequence('user_id_seq'), primary_key=True)
	shop_time = Column(TIMESTAMP)
	amount = Column(Integer)
	attach = Column(String)
	item = Column(String)
	audit_state = Column(Integer)
	status = Column(Integer)
	name = Column(String)

	def __repr__(self):
		return "item:"+self.item
